A Database Error Occurred

Error Number: 1267

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb3_general_ci,COERCIBLE) for operation 'like'

select TP.expected_price as expected_price,TP.product_category as pc_id,TP.productid,protype.name as product_category,TP.make as makeid,make.name as make,TP.part_number as pn, sum(TP.quantity) as quantity,TP.Pic, case TP.ad_purpose when 37 then CONCAT('RS ', LPAD(TP.productid, 5, '0')) END as productcode from tbl_product TP left join tbl_lookupdata make on TP.make=make.id left join tbl_lookupdata protype on TP.product_category=protype.id where TP.part_number LIKE 'AMM12Â%' GROUP BY TP.part_number

Filename: models/Productmodel.php

Line Number: 291